package com.keke.ado.user;

import com.keke.pojo.Role;
import com.keke.pojo.User;

import java.sql.Connection;
import java.sql.SQLException;
import java.util.List;

public interface UserDao {

    //得到登录的用户

    public User getLoginUser(Connection connection, String userCode,String userPassword) throws SQLException;

    //修改当前用户密码
    public int updatePwd(Connection connection,int id,String password)throws SQLException;

    //查询用户总数
    public int getUserCount(Connection connection,String username,int userRole)throws SQLException;

    //通过条件查询userList
    public List<User> getUserList(Connection connection,String username,int userRole,int currentPageNo,int pageSize)throws SQLException;

    //添加用户
    public int add(Connection connection,User user) throws SQLException;

    //删除用户
    public int deleteUserById(Connection connection,int delId) throws SQLException;

    //根据id查询user
    public User getUserById(Connection connection,String id)throws SQLException;

    public int modify(Connection connection, User user) throws SQLException;

    public User getUserByUserCode(Connection connection, String userCode) throws SQLException;
}
